Absolute reference


Absolute reference is a cell reference which does not change when a formula is copied or moved. Absolute references are identified by a ''$'' before the column letter and/or the row number, for example $A$1.

NOTE: Relative reference is the default when creating a new spreadsheet.